package com.ihisun.tmhcms.core.dao.orderdao;

import com.ihisun.tmhcms.core.vo.OrderVo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;
import java.util.Map;

public interface OrderDao extends JpaRepository<OrderVo, Long> {
    @Query(value = "select   order_id, order_state, count(*)as count from o_order GROUP BY  order_state", nativeQuery = true)
    public List<Map<String, Integer>> findByOrderStateCountNum();
    public OrderVo findByOrderId(String orderId);
}
